#!/bin/sh

echo "enter mysql root password "
read mpsw

echo "select id,certificateProfileName from CertificateProfileData where certificateProfileName='CP_eID';" | mysql ejbca  -u root  --password=${mpsw}

echo "select cAId,name from CAData where name='eIDCA';" | mysql ejbca -u root --password=${mpsw}

echo "select id,profileName from EndEntityProfileData where profileName='EEP_eID';"| mysql ejbca -u root --password=${mpsw}

